home *** CD-ROM | disk | FTP | other *** search
/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre1.z / postgre1 / video / script-15 < prev    next >
Encoding:
Text File  |  1992-08-27  |  317 b   |  11 lines

  1. /* 
  2.  * the view definition is equivalent to the following commands:
  3.  */
  4. create toyemp2(name = char16, age = int4, location = point, annualsal = int4)
  5. \g
  6. define rewrite rule toyemp2_ret is
  7. on retrieve to toyemp2 do instead
  8. retrieve(emp.name, emp.age, emp.location, annualsal = 12*emp.salary)
  9. where emp.dept = "toy"
  10. \g
  11.